
<html><HEAD>
<LINK REL=STYLESHEET HREF="default.css" TYPE="text/css">
<TITLE>
Defining the Oracle database interface</TITLE>
</HEAD>
<BODY>

<!-- Header -->
<p class="ancestor" align="right"><A HREF="connpbp67.htm">Previous</A>&nbsp;&nbsp;<A HREF="connpbp69.htm" >Next</A>
<!-- End Header -->
<A NAME="CCJDAAGF"></A><h1>Defining the Oracle database interface</h1>
<A NAME="TI1428"></A><p>To define a connection through an Oracle database interface,
you must create a database profile by supplying values for at least
the basic connection parameters in the Database Profile Setup dialog
box for your Oracle interface. You can then select this profile
at any time to connect to your database in the development environment.</p>
<A NAME="TI1429"></A><p>For information on how to define a database profile, see <A HREF="connpbp7.htm#CEGJAEAF">"Using database profiles"</A>. </p>
<A NAME="X-REF299267753"></A><h2>Specifying the Oracle server connect descriptor</h2>
<A NAME="TI1430"></A><p>To connect to an Oracle database server that resides on a
network, you must specify the proper connect descriptor in the Server
box on the Connection tab of the Database Profile Setup dialog box
for your Oracle interface. The connect descriptor specifies the
connection parameters that Oracle uses to access the database.</p>
<A NAME="TI1431"></A><p>For help determining the proper connect descriptor
for your environment, see your Oracle documentation or system administrator.</p>
<A NAME="TI1432"></A><h4>Specifying a connect descriptor</h4>
<A NAME="TI1433"></A><p>The syntax of the connect descriptor depends on the Oracle
client software you are using.</p>
<A NAME="TI1434"></A><p>If you are using Net9 or later, the syntax is:<p><PRE><i>OracleServiceName</i></PRE></p>
</p>
<A NAME="TI1435"></A><p>If you are using <ACRONYM title = "sequel" >SQL</ACRONYM>*Net
version 2.x, the syntax is: <p><PRE>@ <b>TNS:</b> <i>OracleServiceName</i></PRE></p>
</p>
<A NAME="TI1436"></A><table cellspacing=0 cellpadding=6 border=1 frame="void" rules="all"><tr><th  rowspan="1"  ><A NAME="TI1437"></A>Parameter</th>
<th  rowspan="1"  ><A NAME="TI1438"></A>Description</th>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1439"></A>@</td>
<td  rowspan="1"  ><A NAME="TI1440"></A>The at ( @ ) sign is required </td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1441"></A><b>TNS</b></td>
<td  rowspan="1"  ><A NAME="TI1442"></A>The identifier for the Oracle Transparent
Network Substrate (TNS) technology</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1443"></A><b>:</b></td>
<td  rowspan="1"  ><A NAME="TI1444"></A>The colon ( : ) is required </td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI1445"></A><i>OracleServiceName</i></td>
<td  rowspan="1"  ><A NAME="TI1446"></A>The service name assigned to your server
in the Oracle configuration file for your platform</td>
</tr>
</table>
<p><b>Net9 example</b>   To use Net9 client software to connect to the service named ORA9,
type the following connect descriptor in the Server box on the Connection
tab of the Database Profile Setup dialog box for Oracle9<i>i</i> and
later:<FONT FACE="Courier New"> ORA9</FONT>.</p>

